package com.example.demo.mapper;

import com.example.demo.pojo.Staff;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface StaffMapper {
    List<Staff> queryStaffList();

    Staff queryStaffById(@Param("s_id") int s_id);

    int addStaff(Staff staff);

    int updateStaff(Staff staff);

    int deleteStaff(int s_id);

    List<Staff> getStaffByCondition(@Param("text") String conditionText,
                                            @Param("type") String conditionType,
                                            @Param("gender") String conditionGender,
                                            @Param("j_id") String conditionJob,
                                            @Param("d_id") String conditionDepartment);

}
